In [10]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from plotly.offline import download_plotlyjs,init_notebook_mode,plot,iplot
%matplotlib inline
import cufflinks as cf
In [11]:
init_notebook_mode(connected=True)
In [12]:
cf.go_offline()
In [13]:
df = pd.read_csv(r"C:\Users\HP\Downloads\Dataset\911.csv")
In [14]:
df
Out[14]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:10:52 | NEW HANOVER | REINDEER CT & DEAD END | 1 |
| 1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:29:21 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 |
| 2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 14:39:21 | NORRISTOWN | HAWS AVE | 1 |
| 3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 16:47:36 | NORRISTOWN | AIRY ST & SWEDE ST | 1 |
| 4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 16:56:52 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 |
| 5 | 40.253473 | -75.283245 | CANNON AVE & W 9TH ST; LANSDALE; Station 345;... | 19446.0 | EMS: HEAD INJURY | 2015-12-10 15:39:04 | LANSDALE | CANNON AVE & W 9TH ST | 1 |
| 6 | 40.182111 | -75.127795 | LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... | 19044.0 | EMS: NAUSEA/VOMITING | 2015-12-10 16:46:48 | HORSHAM | LAUREL AVE & OAKDALE AVE | 1 |
| 7 | 40.217286 | -75.405182 | COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... | 19426.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 16:17:05 | SKIPPACK | COLLEGEVILLE RD & LYWISKI RD | 1 |
| 8 | 40.289027 | -75.399590 | MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... | 19438.0 | EMS: SYNCOPAL EPISODE | 2015-12-10 16:51:42 | LOWER SALFORD | MAIN ST & OLD SUMNEYTOWN PIKE | 1 |
| 9 | 40.102398 | -75.291458 | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... | 19462.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:35:41 | PLYMOUTH | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD | 1 |
| 10 | 40.231990 | -75.251891 | RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:33:50 | MONTGOMERY | RT202 PKWY & KNAPP RD | 1 |
| 11 | 40.084161 | -75.308386 | BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... | 19428.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 16:32:10 | PLYMOUTH | BROOK RD & COLWELL LN | 1 |
| 12 | 40.174131 | -75.098491 | BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... | 19040.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:15:49 | UPPER MORELAND | BYBERRY AVE & S WARMINSTER RD | 1 |
| 13 | 40.062974 | -75.135914 | OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... | 19027.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:12:47 | CHELTENHAM | OLD YORK RD & VALLEY RD | 1 |
| 14 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:09:49 | UPPER MERION | SCHUYLKILL EXPY & CROTON RD UNDERPASS | 1 |
| 15 | 40.223778 | -75.235399 | STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... | 18936.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:31:00 | MONTGOMERY | STUMP RD & WITCHWOOD DR | 1 |
| 16 | 40.243258 | -75.286552 | SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... | 19446.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 17:42:44 | LANSDALE | SUSQUEHANNA AVE & W MAIN ST | 1 |
| 17 | 40.312181 | -75.574260 | CHARLOTTE ST & MILES RD; NEW HANOVER; Station... | 19525.0 | EMS: DIZZINESS | 2015-12-10 17:41:54 | NEW HANOVER | CHARLOTTE ST & MILES RD | 1 |
| 18 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... | 19401.0 | EMS: VEHICLE ACCIDENT | 2015-12-10 17:43:29 | NORRISTOWN | PENN ST & ARCH ST | 1 |
| 19 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:45:23 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 |
| 20 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... | 19401.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:43:45 | NORRISTOWN | PENN ST & ARCH ST | 1 |
| 21 | 40.117948 | -75.209848 | CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... | 19031.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:53:22 | WHITEMARSH | CHURCH RD & REDCOAT DR | 1 |
| 22 | 40.199006 | -75.300058 | LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... | 19446.0 | Fire: APPLIANCE FIRE | 2015-12-10 17:59:24 | UPPER GWYNEDD | LILAC CT & PRIMROSE DR | 1 |
| 23 | 40.143326 | -75.422819 | RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... | NaN | Traffic: DISABLED VEHICLE - | 2015-12-10 18:00:38 | LOWER PROVIDENCE | RT422 & PAWLINGS RD OVERPASS | 1 |
| 24 | 40.153268 | -75.189558 | SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:58:22 | UPPER DUBLIN | SUMMIT AVE & RT309 UNDERPASS | 1 |
| 25 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: GENERAL WEAKNESS | 2015-12-10 18:02:02 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 |
| 26 | 40.155283 | -75.264230 | PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... | 19422.0 | EMS: HEAD INJURY | 2015-12-10 18:02:38 | WHITPAIN | PENLLYN BLUE BELL PIKE & VILLAGE CIR | 1 |
| 27 | 40.028903 | -75.351822 | EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... | 19085.0 | Fire: CARBON MONOXIDE DETECTOR | 2015-12-10 18:05:19 | DELAWARE COUNTY | EDENTON PL & DURHAM DR | 1 |
| 28 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 18:05:39 | UPPER MERION | SCHUYLKILL EXPY & WEADLEY RD OVERPASS | 1 |
| 29 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 18:10:40 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 423879 | 40.284894 | -75.583070 | BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... | 19525.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:18:15 | NEW HANOVER | BUCHERT RD & ROMIG RD | 1 |
| 423880 | 40.089043 | -75.154857 | RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... | 19095.0 | Traffic: ROAD OBSTRUCTION - | 2018-11-16 08:18:08 | CHELTENHAM | RICES MILL RD & W CHURCH RD | 1 |
| 423881 | 40.188195 | -75.195506 | TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:17:59 | HORSHAM | TENNIS AVE & WELSH RD | 1 |
| 423882 | 40.188195 | -75.195506 | WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:14:32 | UPPER DUBLIN | WELSH RD & TENNIS AVE | 1 |
| 423883 | 40.175671 | -75.125148 | SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... | 19044.0 | EMS: SUBJECT IN PAIN | 2018-11-16 08:27:45 | HORSHAM | SUMMIT AVE & RUTH AVE | 1 |
| 423884 | 40.277468 | -75.260462 | BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... | 19440.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:30:54 | HATFIELD TOWNSHIP | BETHLEHEM PIKE & TREWIGTOWN RD | 1 |
| 423885 | 40.345292 | -75.509276 | HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... | 18054.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:29:22 | NEW HANOVER | HENNING RD & HILL RD | 1 |
| 423886 | 40.260591 | -75.503238 | YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... | 19473.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:30:00 | LOWER FREDERICK | YERGER RD & N RYANFORD RD | 1 |
| 423887 | 40.136020 | -75.354606 | BEECH DR & SPRUCE ST; WEST NORRITON; Station ... | 19403.0 | EMS: SEIZURES | 2018-11-16 08:39:28 | WEST NORRITON | BEECH DR & SPRUCE ST | 1 |
| 423888 | 40.230934 | -75.522125 | LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... | 19468.0 | Fire: FIRE ALARM | 2018-11-16 08:39:53 | LIMERICK | LIGHTCAP RD & SANATOGA SPRINGS DR | 1 |
| 423889 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 |
| 423890 | 40.335354 | -75.511268 | HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... | 18074.0 | Fire: FIRE POLICE NEEDED | 2018-11-16 08:45:04 | NEW HANOVER | HENNING RD | 1 |
| 423891 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 |
| 423892 | 40.107400 | -75.113206 | THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... | 19046.0 | Fire: FIRE ALARM | 2018-11-16 08:49:48 | ABINGTON | THE FAIRWAY & RYDAL RD | 1 |
| 423893 | 40.256628 | -75.261270 | LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... | 19446.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:48:24 | HATFIELD TOWNSHIP | LINE ST & COWPATH RD | 1 |
| 423894 | 40.183361 | -75.542285 | MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... | 19468.0 | EMS: FALL VICTIM | 2018-11-16 08:50:58 | ROYERSFORD | MAIN ST & 2ND AVE | 1 |
| 423895 | 40.184797 | -75.286879 | TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... | 19422.0 | EMS: SYNCOPAL EPISODE | 2018-11-16 08:47:05 | WHITPAIN | TWIN SILO DR & MORRIS RD | 1 |
| 423896 | 40.254344 | -75.407617 | HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; | NaN | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | UPPER SALFORD | HOFFMAN | 1 |
| 423897 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 |
| 423898 | 40.142797 | -75.495065 | MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... | 19460.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:43:42 | UPPER PROVIDENCE | MAC DADE RD & SCARLET OAK DR | 1 |
| 423899 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 |
| 423900 | 40.157913 | -75.203632 | HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; | 19002.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | AMBLER | HOFFMAN | 1 |
| 423901 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: MEDICAL ALERT ALARM | 2018-11-16 08:53:03 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 |
| 423902 | 40.271663 | -75.238440 | RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... | 18914.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:55:36 | MONTGOMERY | RICHARDSON RD & COUNTY LINE RD | 1 |
| 423903 | 40.235373 | -75.224751 | HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... | 19454.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:54:52 | MONTGOMERY | HORSHAM RD & STUMP RD | 1 |
| 423904 | 40.139993 | -75.049864 | BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... | 19006.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:08 | LOWER MORELAND | BUCK RD & WOODWARD DR | 1 |
| 423905 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:53:32 | LOWER SALFORD | OAK DR & MOYER RD | 1 |
| 423906 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:19 | LOWER SALFORD | OAK DR & MOYER RD | 1 |
| 423907 | 40.190946 | -75.237285 | SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:51:48 | LOWER GWYNEDD | SUMNEYTOWN PIKE & WELLINGTON DR | 1 |
| 423908 | 40.155164 | -75.264665 | HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; | 19422.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | LOWER GWYNEDD | HOFFMAN | 1 |
423909 rows × 9 columns
In [15]:
df.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 423909 entries, 0 to 423908 Data columns (total 9 columns): lat 423909 non-null float64 lng 423909 non-null float64 desc 423909 non-null object zip 371780 non-null float64 title 423909 non-null object timeStamp 423909 non-null object twp 423750 non-null object addr 423909 non-null object e 423909 non-null int64 dtypes: float64(3), int64(1), object(5) memory usage: 29.1+ MB
In [16]:
df["twp"].value_counts().head(10)
Out[16]:
LOWER MERION 36441 ABINGTON 25835 NORRISTOWN 23883 UPPER MERION 22694 CHELTENHAM 19629 POTTSTOWN 17500 UPPER MORELAND 14707 LOWER PROVIDENCE 14025 PLYMOUTH 12800 UPPER DUBLIN 11910 Name: twp, dtype: int64
In [17]:
df["timeStamp"] = pd.to_datetime(df["timeStamp"])
In [18]:
df["timeStamp"].value_counts().head(10)
Out[18]:
2018-10-06 19:26:38 9 2018-07-09 13:23:16 8 2017-02-09 07:17:58 6 2016-06-01 16:34:27 6 2016-07-10 19:00:45 6 2016-07-20 06:42:37 6 2018-11-03 10:35:24 5 2017-03-05 09:02:35 5 2015-12-12 05:22:51 5 2017-05-29 12:22:45 5 Name: timeStamp, dtype: int64
In [19]:
df["title"].nunique()
Out[19]:
141
In [20]:
df["title"].head(10)
Out[20]:
0 EMS: BACK PAINS/INJURY 1 EMS: DIABETIC EMERGENCY 2 Fire: GAS-ODOR/LEAK 3 EMS: CARDIAC EMERGENCY 4 EMS: DIZZINESS 5 EMS: HEAD INJURY 6 EMS: NAUSEA/VOMITING 7 EMS: RESPIRATORY EMERGENCY 8 EMS: SYNCOPAL EPISODE 9 Traffic: VEHICLE ACCIDENT - Name: title, dtype: object
In [21]:
df["short"] = df["title"].apply(lambda x:x.split(":")[0])
In [22]:
df["short"].head(10)
Out[22]:
0 EMS 1 EMS 2 Fire 3 EMS 4 EMS 5 EMS 6 EMS 7 EMS 8 EMS 9 Traffic Name: short, dtype: object
In [23]:
df
Out[23]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | short | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:10:52 | NEW HANOVER | REINDEER CT & DEAD END | 1 | EMS |
| 1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:29:21 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 | EMS |
| 2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 14:39:21 | NORRISTOWN | HAWS AVE | 1 | Fire |
| 3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 16:47:36 | NORRISTOWN | AIRY ST & SWEDE ST | 1 | EMS |
| 4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 16:56:52 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 | EMS |
| 5 | 40.253473 | -75.283245 | CANNON AVE & W 9TH ST; LANSDALE; Station 345;... | 19446.0 | EMS: HEAD INJURY | 2015-12-10 15:39:04 | LANSDALE | CANNON AVE & W 9TH ST | 1 | EMS |
| 6 | 40.182111 | -75.127795 | LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... | 19044.0 | EMS: NAUSEA/VOMITING | 2015-12-10 16:46:48 | HORSHAM | LAUREL AVE & OAKDALE AVE | 1 | EMS |
| 7 | 40.217286 | -75.405182 | COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... | 19426.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 16:17:05 | SKIPPACK | COLLEGEVILLE RD & LYWISKI RD | 1 | EMS |
| 8 | 40.289027 | -75.399590 | MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... | 19438.0 | EMS: SYNCOPAL EPISODE | 2015-12-10 16:51:42 | LOWER SALFORD | MAIN ST & OLD SUMNEYTOWN PIKE | 1 | EMS |
| 9 | 40.102398 | -75.291458 | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... | 19462.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:35:41 | PLYMOUTH | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD | 1 | Traffic |
| 10 | 40.231990 | -75.251891 | RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:33:50 | MONTGOMERY | RT202 PKWY & KNAPP RD | 1 | Traffic |
| 11 | 40.084161 | -75.308386 | BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... | 19428.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 16:32:10 | PLYMOUTH | BROOK RD & COLWELL LN | 1 | Traffic |
| 12 | 40.174131 | -75.098491 | BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... | 19040.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:15:49 | UPPER MORELAND | BYBERRY AVE & S WARMINSTER RD | 1 | Traffic |
| 13 | 40.062974 | -75.135914 | OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... | 19027.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:12:47 | CHELTENHAM | OLD YORK RD & VALLEY RD | 1 | Traffic |
| 14 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:09:49 | UPPER MERION | SCHUYLKILL EXPY & CROTON RD UNDERPASS | 1 | Traffic |
| 15 | 40.223778 | -75.235399 | STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... | 18936.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:31:00 | MONTGOMERY | STUMP RD & WITCHWOOD DR | 1 | Traffic |
| 16 | 40.243258 | -75.286552 | SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... | 19446.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 17:42:44 | LANSDALE | SUSQUEHANNA AVE & W MAIN ST | 1 | EMS |
| 17 | 40.312181 | -75.574260 | CHARLOTTE ST & MILES RD; NEW HANOVER; Station... | 19525.0 | EMS: DIZZINESS | 2015-12-10 17:41:54 | NEW HANOVER | CHARLOTTE ST & MILES RD | 1 | EMS |
| 18 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... | 19401.0 | EMS: VEHICLE ACCIDENT | 2015-12-10 17:43:29 | NORRISTOWN | PENN ST & ARCH ST | 1 | EMS |
| 19 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:45:23 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic |
| 20 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... | 19401.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:43:45 | NORRISTOWN | PENN ST & ARCH ST | 1 | Traffic |
| 21 | 40.117948 | -75.209848 | CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... | 19031.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:53:22 | WHITEMARSH | CHURCH RD & REDCOAT DR | 1 | Traffic |
| 22 | 40.199006 | -75.300058 | LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... | 19446.0 | Fire: APPLIANCE FIRE | 2015-12-10 17:59:24 | UPPER GWYNEDD | LILAC CT & PRIMROSE DR | 1 | Fire |
| 23 | 40.143326 | -75.422819 | RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... | NaN | Traffic: DISABLED VEHICLE - | 2015-12-10 18:00:38 | LOWER PROVIDENCE | RT422 & PAWLINGS RD OVERPASS | 1 | Traffic |
| 24 | 40.153268 | -75.189558 | SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:58:22 | UPPER DUBLIN | SUMMIT AVE & RT309 UNDERPASS | 1 | Traffic |
| 25 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: GENERAL WEAKNESS | 2015-12-10 18:02:02 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS |
| 26 | 40.155283 | -75.264230 | PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... | 19422.0 | EMS: HEAD INJURY | 2015-12-10 18:02:38 | WHITPAIN | PENLLYN BLUE BELL PIKE & VILLAGE CIR | 1 | EMS |
| 27 | 40.028903 | -75.351822 | EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... | 19085.0 | Fire: CARBON MONOXIDE DETECTOR | 2015-12-10 18:05:19 | DELAWARE COUNTY | EDENTON PL & DURHAM DR | 1 | Fire |
| 28 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 18:05:39 | UPPER MERION | SCHUYLKILL EXPY & WEADLEY RD OVERPASS | 1 | Traffic |
| 29 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 18:10:40 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 423879 | 40.284894 | -75.583070 | BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... | 19525.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:18:15 | NEW HANOVER | BUCHERT RD & ROMIG RD | 1 | Traffic |
| 423880 | 40.089043 | -75.154857 | RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... | 19095.0 | Traffic: ROAD OBSTRUCTION - | 2018-11-16 08:18:08 | CHELTENHAM | RICES MILL RD & W CHURCH RD | 1 | Traffic |
| 423881 | 40.188195 | -75.195506 | TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:17:59 | HORSHAM | TENNIS AVE & WELSH RD | 1 | Traffic |
| 423882 | 40.188195 | -75.195506 | WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:14:32 | UPPER DUBLIN | WELSH RD & TENNIS AVE | 1 | Traffic |
| 423883 | 40.175671 | -75.125148 | SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... | 19044.0 | EMS: SUBJECT IN PAIN | 2018-11-16 08:27:45 | HORSHAM | SUMMIT AVE & RUTH AVE | 1 | EMS |
| 423884 | 40.277468 | -75.260462 | BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... | 19440.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:30:54 | HATFIELD TOWNSHIP | BETHLEHEM PIKE & TREWIGTOWN RD | 1 | Fire |
| 423885 | 40.345292 | -75.509276 | HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... | 18054.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:29:22 | NEW HANOVER | HENNING RD & HILL RD | 1 | Traffic |
| 423886 | 40.260591 | -75.503238 | YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... | 19473.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:30:00 | LOWER FREDERICK | YERGER RD & N RYANFORD RD | 1 | Traffic |
| 423887 | 40.136020 | -75.354606 | BEECH DR & SPRUCE ST; WEST NORRITON; Station ... | 19403.0 | EMS: SEIZURES | 2018-11-16 08:39:28 | WEST NORRITON | BEECH DR & SPRUCE ST | 1 | EMS |
| 423888 | 40.230934 | -75.522125 | LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... | 19468.0 | Fire: FIRE ALARM | 2018-11-16 08:39:53 | LIMERICK | LIGHTCAP RD & SANATOGA SPRINGS DR | 1 | Fire |
| 423889 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic |
| 423890 | 40.335354 | -75.511268 | HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... | 18074.0 | Fire: FIRE POLICE NEEDED | 2018-11-16 08:45:04 | NEW HANOVER | HENNING RD | 1 | Fire |
| 423891 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic |
| 423892 | 40.107400 | -75.113206 | THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... | 19046.0 | Fire: FIRE ALARM | 2018-11-16 08:49:48 | ABINGTON | THE FAIRWAY & RYDAL RD | 1 | Fire |
| 423893 | 40.256628 | -75.261270 | LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... | 19446.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:48:24 | HATFIELD TOWNSHIP | LINE ST & COWPATH RD | 1 | Fire |
| 423894 | 40.183361 | -75.542285 | MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... | 19468.0 | EMS: FALL VICTIM | 2018-11-16 08:50:58 | ROYERSFORD | MAIN ST & 2ND AVE | 1 | EMS |
| 423895 | 40.184797 | -75.286879 | TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... | 19422.0 | EMS: SYNCOPAL EPISODE | 2018-11-16 08:47:05 | WHITPAIN | TWIN SILO DR & MORRIS RD | 1 | EMS |
| 423896 | 40.254344 | -75.407617 | HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; | NaN | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | UPPER SALFORD | HOFFMAN | 1 | Traffic |
| 423897 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic |
| 423898 | 40.142797 | -75.495065 | MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... | 19460.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:43:42 | UPPER PROVIDENCE | MAC DADE RD & SCARLET OAK DR | 1 | Traffic |
| 423899 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic |
| 423900 | 40.157913 | -75.203632 | HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; | 19002.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | AMBLER | HOFFMAN | 1 | Traffic |
| 423901 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: MEDICAL ALERT ALARM | 2018-11-16 08:53:03 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS |
| 423902 | 40.271663 | -75.238440 | RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... | 18914.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:55:36 | MONTGOMERY | RICHARDSON RD & COUNTY LINE RD | 1 | Traffic |
| 423903 | 40.235373 | -75.224751 | HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... | 19454.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:54:52 | MONTGOMERY | HORSHAM RD & STUMP RD | 1 | Traffic |
| 423904 | 40.139993 | -75.049864 | BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... | 19006.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:08 | LOWER MORELAND | BUCK RD & WOODWARD DR | 1 | Traffic |
| 423905 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:53:32 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic |
| 423906 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:19 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic |
| 423907 | 40.190946 | -75.237285 | SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:51:48 | LOWER GWYNEDD | SUMNEYTOWN PIKE & WELLINGTON DR | 1 | Traffic |
| 423908 | 40.155164 | -75.264665 | HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; | 19422.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | LOWER GWYNEDD | HOFFMAN | 1 | Traffic |
423909 rows × 10 columns
In [24]:
df["short"].value_counts().head()
Out[24]:
EMS 208676 Traffic 151458 Fire 63775 Name: short, dtype: int64
In [91]:
sns.countplot(x="short", data=df, palette="Set2")
plt.tight_layout(rect=[0, 0.02, 3, 2])
In [26]:
df["hour"] = df["timeStamp"].apply(lambda x:x.hour)
In [27]:
df["hour"].value_counts().head(10)
Out[27]:
17 27933 16 27738 15 26976 14 25836 12 25486 13 25460 11 24263 18 24071 10 23334 9 22715 Name: hour, dtype: int64
In [28]:
df["months"] = df["timeStamp"].apply(lambda x:x.month)
In [29]:
df["months"].value_counts().head(10)
Out[29]:
1 37824 10 37815 3 37666 7 36405 6 36171 8 35972 5 35644 9 35339 4 33583 12 33019 Name: months, dtype: int64
In [30]:
df["day"] = df["timeStamp"].apply(lambda x:x.dayofweek)
In [31]:
df["day"].value_counts()
Out[31]:
4 65751 2 63423 3 63159 1 63041 0 61318 5 57093 6 50124 Name: day, dtype: int64
In [32]:
df
Out[32]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | short | hour | months | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:10:52 | NEW HANOVER | REINDEER CT & DEAD END | 1 | EMS | 17 | 12 | 3 |
| 1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:29:21 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 | EMS | 17 | 12 | 3 |
| 2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 14:39:21 | NORRISTOWN | HAWS AVE | 1 | Fire | 14 | 12 | 3 |
| 3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 16:47:36 | NORRISTOWN | AIRY ST & SWEDE ST | 1 | EMS | 16 | 12 | 3 |
| 4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 16:56:52 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 | EMS | 16 | 12 | 3 |
| 5 | 40.253473 | -75.283245 | CANNON AVE & W 9TH ST; LANSDALE; Station 345;... | 19446.0 | EMS: HEAD INJURY | 2015-12-10 15:39:04 | LANSDALE | CANNON AVE & W 9TH ST | 1 | EMS | 15 | 12 | 3 |
| 6 | 40.182111 | -75.127795 | LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... | 19044.0 | EMS: NAUSEA/VOMITING | 2015-12-10 16:46:48 | HORSHAM | LAUREL AVE & OAKDALE AVE | 1 | EMS | 16 | 12 | 3 |
| 7 | 40.217286 | -75.405182 | COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... | 19426.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 16:17:05 | SKIPPACK | COLLEGEVILLE RD & LYWISKI RD | 1 | EMS | 16 | 12 | 3 |
| 8 | 40.289027 | -75.399590 | MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... | 19438.0 | EMS: SYNCOPAL EPISODE | 2015-12-10 16:51:42 | LOWER SALFORD | MAIN ST & OLD SUMNEYTOWN PIKE | 1 | EMS | 16 | 12 | 3 |
| 9 | 40.102398 | -75.291458 | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... | 19462.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:35:41 | PLYMOUTH | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD | 1 | Traffic | 17 | 12 | 3 |
| 10 | 40.231990 | -75.251891 | RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:33:50 | MONTGOMERY | RT202 PKWY & KNAPP RD | 1 | Traffic | 17 | 12 | 3 |
| 11 | 40.084161 | -75.308386 | BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... | 19428.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 16:32:10 | PLYMOUTH | BROOK RD & COLWELL LN | 1 | Traffic | 16 | 12 | 3 |
| 12 | 40.174131 | -75.098491 | BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... | 19040.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:15:49 | UPPER MORELAND | BYBERRY AVE & S WARMINSTER RD | 1 | Traffic | 17 | 12 | 3 |
| 13 | 40.062974 | -75.135914 | OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... | 19027.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:12:47 | CHELTENHAM | OLD YORK RD & VALLEY RD | 1 | Traffic | 17 | 12 | 3 |
| 14 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:09:49 | UPPER MERION | SCHUYLKILL EXPY & CROTON RD UNDERPASS | 1 | Traffic | 17 | 12 | 3 |
| 15 | 40.223778 | -75.235399 | STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... | 18936.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:31:00 | MONTGOMERY | STUMP RD & WITCHWOOD DR | 1 | Traffic | 17 | 12 | 3 |
| 16 | 40.243258 | -75.286552 | SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... | 19446.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 17:42:44 | LANSDALE | SUSQUEHANNA AVE & W MAIN ST | 1 | EMS | 17 | 12 | 3 |
| 17 | 40.312181 | -75.574260 | CHARLOTTE ST & MILES RD; NEW HANOVER; Station... | 19525.0 | EMS: DIZZINESS | 2015-12-10 17:41:54 | NEW HANOVER | CHARLOTTE ST & MILES RD | 1 | EMS | 17 | 12 | 3 |
| 18 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... | 19401.0 | EMS: VEHICLE ACCIDENT | 2015-12-10 17:43:29 | NORRISTOWN | PENN ST & ARCH ST | 1 | EMS | 17 | 12 | 3 |
| 19 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:45:23 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 17 | 12 | 3 |
| 20 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... | 19401.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:43:45 | NORRISTOWN | PENN ST & ARCH ST | 1 | Traffic | 17 | 12 | 3 |
| 21 | 40.117948 | -75.209848 | CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... | 19031.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:53:22 | WHITEMARSH | CHURCH RD & REDCOAT DR | 1 | Traffic | 17 | 12 | 3 |
| 22 | 40.199006 | -75.300058 | LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... | 19446.0 | Fire: APPLIANCE FIRE | 2015-12-10 17:59:24 | UPPER GWYNEDD | LILAC CT & PRIMROSE DR | 1 | Fire | 17 | 12 | 3 |
| 23 | 40.143326 | -75.422819 | RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... | NaN | Traffic: DISABLED VEHICLE - | 2015-12-10 18:00:38 | LOWER PROVIDENCE | RT422 & PAWLINGS RD OVERPASS | 1 | Traffic | 18 | 12 | 3 |
| 24 | 40.153268 | -75.189558 | SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:58:22 | UPPER DUBLIN | SUMMIT AVE & RT309 UNDERPASS | 1 | Traffic | 17 | 12 | 3 |
| 25 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: GENERAL WEAKNESS | 2015-12-10 18:02:02 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 18 | 12 | 3 |
| 26 | 40.155283 | -75.264230 | PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... | 19422.0 | EMS: HEAD INJURY | 2015-12-10 18:02:38 | WHITPAIN | PENLLYN BLUE BELL PIKE & VILLAGE CIR | 1 | EMS | 18 | 12 | 3 |
| 27 | 40.028903 | -75.351822 | EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... | 19085.0 | Fire: CARBON MONOXIDE DETECTOR | 2015-12-10 18:05:19 | DELAWARE COUNTY | EDENTON PL & DURHAM DR | 1 | Fire | 18 | 12 | 3 |
| 28 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 18:05:39 | UPPER MERION | SCHUYLKILL EXPY & WEADLEY RD OVERPASS | 1 | Traffic | 18 | 12 | 3 |
| 29 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 18:10:40 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 18 | 12 | 3 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 423879 | 40.284894 | -75.583070 | BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... | 19525.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:18:15 | NEW HANOVER | BUCHERT RD & ROMIG RD | 1 | Traffic | 8 | 11 | 4 |
| 423880 | 40.089043 | -75.154857 | RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... | 19095.0 | Traffic: ROAD OBSTRUCTION - | 2018-11-16 08:18:08 | CHELTENHAM | RICES MILL RD & W CHURCH RD | 1 | Traffic | 8 | 11 | 4 |
| 423881 | 40.188195 | -75.195506 | TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:17:59 | HORSHAM | TENNIS AVE & WELSH RD | 1 | Traffic | 8 | 11 | 4 |
| 423882 | 40.188195 | -75.195506 | WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:14:32 | UPPER DUBLIN | WELSH RD & TENNIS AVE | 1 | Traffic | 8 | 11 | 4 |
| 423883 | 40.175671 | -75.125148 | SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... | 19044.0 | EMS: SUBJECT IN PAIN | 2018-11-16 08:27:45 | HORSHAM | SUMMIT AVE & RUTH AVE | 1 | EMS | 8 | 11 | 4 |
| 423884 | 40.277468 | -75.260462 | BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... | 19440.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:30:54 | HATFIELD TOWNSHIP | BETHLEHEM PIKE & TREWIGTOWN RD | 1 | Fire | 8 | 11 | 4 |
| 423885 | 40.345292 | -75.509276 | HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... | 18054.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:29:22 | NEW HANOVER | HENNING RD & HILL RD | 1 | Traffic | 8 | 11 | 4 |
| 423886 | 40.260591 | -75.503238 | YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... | 19473.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:30:00 | LOWER FREDERICK | YERGER RD & N RYANFORD RD | 1 | Traffic | 8 | 11 | 4 |
| 423887 | 40.136020 | -75.354606 | BEECH DR & SPRUCE ST; WEST NORRITON; Station ... | 19403.0 | EMS: SEIZURES | 2018-11-16 08:39:28 | WEST NORRITON | BEECH DR & SPRUCE ST | 1 | EMS | 8 | 11 | 4 |
| 423888 | 40.230934 | -75.522125 | LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... | 19468.0 | Fire: FIRE ALARM | 2018-11-16 08:39:53 | LIMERICK | LIGHTCAP RD & SANATOGA SPRINGS DR | 1 | Fire | 8 | 11 | 4 |
| 423889 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 |
| 423890 | 40.335354 | -75.511268 | HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... | 18074.0 | Fire: FIRE POLICE NEEDED | 2018-11-16 08:45:04 | NEW HANOVER | HENNING RD | 1 | Fire | 8 | 11 | 4 |
| 423891 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 |
| 423892 | 40.107400 | -75.113206 | THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... | 19046.0 | Fire: FIRE ALARM | 2018-11-16 08:49:48 | ABINGTON | THE FAIRWAY & RYDAL RD | 1 | Fire | 8 | 11 | 4 |
| 423893 | 40.256628 | -75.261270 | LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... | 19446.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:48:24 | HATFIELD TOWNSHIP | LINE ST & COWPATH RD | 1 | Fire | 8 | 11 | 4 |
| 423894 | 40.183361 | -75.542285 | MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... | 19468.0 | EMS: FALL VICTIM | 2018-11-16 08:50:58 | ROYERSFORD | MAIN ST & 2ND AVE | 1 | EMS | 8 | 11 | 4 |
| 423895 | 40.184797 | -75.286879 | TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... | 19422.0 | EMS: SYNCOPAL EPISODE | 2018-11-16 08:47:05 | WHITPAIN | TWIN SILO DR & MORRIS RD | 1 | EMS | 8 | 11 | 4 |
| 423896 | 40.254344 | -75.407617 | HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; | NaN | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | UPPER SALFORD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
| 423897 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 |
| 423898 | 40.142797 | -75.495065 | MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... | 19460.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:43:42 | UPPER PROVIDENCE | MAC DADE RD & SCARLET OAK DR | 1 | Traffic | 8 | 11 | 4 |
| 423899 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 |
| 423900 | 40.157913 | -75.203632 | HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; | 19002.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | AMBLER | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
| 423901 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: MEDICAL ALERT ALARM | 2018-11-16 08:53:03 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 8 | 11 | 4 |
| 423902 | 40.271663 | -75.238440 | RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... | 18914.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:55:36 | MONTGOMERY | RICHARDSON RD & COUNTY LINE RD | 1 | Traffic | 8 | 11 | 4 |
| 423903 | 40.235373 | -75.224751 | HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... | 19454.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:54:52 | MONTGOMERY | HORSHAM RD & STUMP RD | 1 | Traffic | 8 | 11 | 4 |
| 423904 | 40.139993 | -75.049864 | BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... | 19006.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:08 | LOWER MORELAND | BUCK RD & WOODWARD DR | 1 | Traffic | 8 | 11 | 4 |
| 423905 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:53:32 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 |
| 423906 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:19 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 |
| 423907 | 40.190946 | -75.237285 | SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:51:48 | LOWER GWYNEDD | SUMNEYTOWN PIKE & WELLINGTON DR | 1 | Traffic | 8 | 11 | 4 |
| 423908 | 40.155164 | -75.264665 | HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; | 19422.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | LOWER GWYNEDD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
423909 rows × 13 columns
In [33]:
mapping = {1:"MON",2:"TUE",3:"WED",4:"THU",5:"FRI",6:"SAT",7:"SUN"}
daysofweek = df["day"].map(mapping)
In [34]:
daysofweek.value_counts()
Out[34]:
THU 65751 TUE 63423 WED 63159 MON 63041 FRI 57093 SAT 50124 Name: day, dtype: int64
In [90]:
sns.countplot(x=daysofweek,data=df,hue="short", palette="Set2")
plt.tight_layout(rect=[0, 0.02, 3, 2])
In [36]:
bymonth = df.groupby(df["months"]).count()
In [37]:
bymonth
Out[37]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | short | hour | months | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| months | |||||||||||||
| 1 | 37824 | 37824 | 37824 | 33480 | 37824 | 37824 | 37812 | 37824 | 37824 | 37824 | 37824 | 37824 | 37824 |
| 2 | 32828 | 32828 | 32828 | 28963 | 32828 | 32828 | 32817 | 32828 | 32828 | 32828 | 32828 | 32828 | 32828 |
| 3 | 37666 | 37666 | 37666 | 33416 | 37666 | 37666 | 37651 | 37666 | 37666 | 37666 | 37666 | 37666 | 37666 |
| 4 | 33583 | 33583 | 33583 | 29488 | 33583 | 33583 | 33575 | 33583 | 33583 | 33583 | 33583 | 33583 | 33583 |
| 5 | 35644 | 35644 | 35644 | 31114 | 35644 | 35644 | 35628 | 35644 | 35644 | 35644 | 35644 | 35644 | 35644 |
| 6 | 36171 | 36171 | 36171 | 31501 | 36171 | 36171 | 36152 | 36171 | 36171 | 36171 | 36171 | 36171 | 36171 |
| 7 | 36405 | 36405 | 36405 | 31863 | 36405 | 36405 | 36391 | 36405 | 36405 | 36405 | 36405 | 36405 | 36405 |
| 8 | 35972 | 35972 | 35972 | 31512 | 35972 | 35972 | 35957 | 35972 | 35972 | 35972 | 35972 | 35972 | 35972 |
| 9 | 35339 | 35339 | 35339 | 30772 | 35339 | 35339 | 35325 | 35339 | 35339 | 35339 | 35339 | 35339 | 35339 |
| 10 | 37815 | 37815 | 37815 | 32919 | 37815 | 37815 | 37809 | 37815 | 37815 | 37815 | 37815 | 37815 | 37815 |
| 11 | 31643 | 31643 | 31643 | 27776 | 31643 | 31643 | 31628 | 31643 | 31643 | 31643 | 31643 | 31643 | 31643 |
| 12 | 33019 | 33019 | 33019 | 28976 | 33019 | 33019 | 33005 | 33019 | 33019 | 33019 | 33019 | 33019 | 33019 |
In [94]:
bymonth["months"].iplot(linewidth=5, color='red')
plt.tight_layout(rect=[0, 0.02, 3, 1])
<matplotlib.figure.Figure at 0x294cbf87c18>
In [40]:
df
Out[40]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | short | hour | months | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:10:52 | NEW HANOVER | REINDEER CT & DEAD END | 1 | EMS | 17 | 12 | 3 |
| 1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:29:21 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 | EMS | 17 | 12 | 3 |
| 2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 14:39:21 | NORRISTOWN | HAWS AVE | 1 | Fire | 14 | 12 | 3 |
| 3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 16:47:36 | NORRISTOWN | AIRY ST & SWEDE ST | 1 | EMS | 16 | 12 | 3 |
| 4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 16:56:52 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 | EMS | 16 | 12 | 3 |
| 5 | 40.253473 | -75.283245 | CANNON AVE & W 9TH ST; LANSDALE; Station 345;... | 19446.0 | EMS: HEAD INJURY | 2015-12-10 15:39:04 | LANSDALE | CANNON AVE & W 9TH ST | 1 | EMS | 15 | 12 | 3 |
| 6 | 40.182111 | -75.127795 | LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... | 19044.0 | EMS: NAUSEA/VOMITING | 2015-12-10 16:46:48 | HORSHAM | LAUREL AVE & OAKDALE AVE | 1 | EMS | 16 | 12 | 3 |
| 7 | 40.217286 | -75.405182 | COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... | 19426.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 16:17:05 | SKIPPACK | COLLEGEVILLE RD & LYWISKI RD | 1 | EMS | 16 | 12 | 3 |
| 8 | 40.289027 | -75.399590 | MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... | 19438.0 | EMS: SYNCOPAL EPISODE | 2015-12-10 16:51:42 | LOWER SALFORD | MAIN ST & OLD SUMNEYTOWN PIKE | 1 | EMS | 16 | 12 | 3 |
| 9 | 40.102398 | -75.291458 | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... | 19462.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:35:41 | PLYMOUTH | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD | 1 | Traffic | 17 | 12 | 3 |
| 10 | 40.231990 | -75.251891 | RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:33:50 | MONTGOMERY | RT202 PKWY & KNAPP RD | 1 | Traffic | 17 | 12 | 3 |
| 11 | 40.084161 | -75.308386 | BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... | 19428.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 16:32:10 | PLYMOUTH | BROOK RD & COLWELL LN | 1 | Traffic | 16 | 12 | 3 |
| 12 | 40.174131 | -75.098491 | BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... | 19040.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:15:49 | UPPER MORELAND | BYBERRY AVE & S WARMINSTER RD | 1 | Traffic | 17 | 12 | 3 |
| 13 | 40.062974 | -75.135914 | OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... | 19027.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:12:47 | CHELTENHAM | OLD YORK RD & VALLEY RD | 1 | Traffic | 17 | 12 | 3 |
| 14 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:09:49 | UPPER MERION | SCHUYLKILL EXPY & CROTON RD UNDERPASS | 1 | Traffic | 17 | 12 | 3 |
| 15 | 40.223778 | -75.235399 | STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... | 18936.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:31:00 | MONTGOMERY | STUMP RD & WITCHWOOD DR | 1 | Traffic | 17 | 12 | 3 |
| 16 | 40.243258 | -75.286552 | SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... | 19446.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 17:42:44 | LANSDALE | SUSQUEHANNA AVE & W MAIN ST | 1 | EMS | 17 | 12 | 3 |
| 17 | 40.312181 | -75.574260 | CHARLOTTE ST & MILES RD; NEW HANOVER; Station... | 19525.0 | EMS: DIZZINESS | 2015-12-10 17:41:54 | NEW HANOVER | CHARLOTTE ST & MILES RD | 1 | EMS | 17 | 12 | 3 |
| 18 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... | 19401.0 | EMS: VEHICLE ACCIDENT | 2015-12-10 17:43:29 | NORRISTOWN | PENN ST & ARCH ST | 1 | EMS | 17 | 12 | 3 |
| 19 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:45:23 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 17 | 12 | 3 |
| 20 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... | 19401.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:43:45 | NORRISTOWN | PENN ST & ARCH ST | 1 | Traffic | 17 | 12 | 3 |
| 21 | 40.117948 | -75.209848 | CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... | 19031.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:53:22 | WHITEMARSH | CHURCH RD & REDCOAT DR | 1 | Traffic | 17 | 12 | 3 |
| 22 | 40.199006 | -75.300058 | LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... | 19446.0 | Fire: APPLIANCE FIRE | 2015-12-10 17:59:24 | UPPER GWYNEDD | LILAC CT & PRIMROSE DR | 1 | Fire | 17 | 12 | 3 |
| 23 | 40.143326 | -75.422819 | RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... | NaN | Traffic: DISABLED VEHICLE - | 2015-12-10 18:00:38 | LOWER PROVIDENCE | RT422 & PAWLINGS RD OVERPASS | 1 | Traffic | 18 | 12 | 3 |
| 24 | 40.153268 | -75.189558 | SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:58:22 | UPPER DUBLIN | SUMMIT AVE & RT309 UNDERPASS | 1 | Traffic | 17 | 12 | 3 |
| 25 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: GENERAL WEAKNESS | 2015-12-10 18:02:02 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 18 | 12 | 3 |
| 26 | 40.155283 | -75.264230 | PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... | 19422.0 | EMS: HEAD INJURY | 2015-12-10 18:02:38 | WHITPAIN | PENLLYN BLUE BELL PIKE & VILLAGE CIR | 1 | EMS | 18 | 12 | 3 |
| 27 | 40.028903 | -75.351822 | EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... | 19085.0 | Fire: CARBON MONOXIDE DETECTOR | 2015-12-10 18:05:19 | DELAWARE COUNTY | EDENTON PL & DURHAM DR | 1 | Fire | 18 | 12 | 3 |
| 28 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 18:05:39 | UPPER MERION | SCHUYLKILL EXPY & WEADLEY RD OVERPASS | 1 | Traffic | 18 | 12 | 3 |
| 29 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 18:10:40 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 18 | 12 | 3 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 423879 | 40.284894 | -75.583070 | BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... | 19525.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:18:15 | NEW HANOVER | BUCHERT RD & ROMIG RD | 1 | Traffic | 8 | 11 | 4 |
| 423880 | 40.089043 | -75.154857 | RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... | 19095.0 | Traffic: ROAD OBSTRUCTION - | 2018-11-16 08:18:08 | CHELTENHAM | RICES MILL RD & W CHURCH RD | 1 | Traffic | 8 | 11 | 4 |
| 423881 | 40.188195 | -75.195506 | TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:17:59 | HORSHAM | TENNIS AVE & WELSH RD | 1 | Traffic | 8 | 11 | 4 |
| 423882 | 40.188195 | -75.195506 | WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:14:32 | UPPER DUBLIN | WELSH RD & TENNIS AVE | 1 | Traffic | 8 | 11 | 4 |
| 423883 | 40.175671 | -75.125148 | SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... | 19044.0 | EMS: SUBJECT IN PAIN | 2018-11-16 08:27:45 | HORSHAM | SUMMIT AVE & RUTH AVE | 1 | EMS | 8 | 11 | 4 |
| 423884 | 40.277468 | -75.260462 | BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... | 19440.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:30:54 | HATFIELD TOWNSHIP | BETHLEHEM PIKE & TREWIGTOWN RD | 1 | Fire | 8 | 11 | 4 |
| 423885 | 40.345292 | -75.509276 | HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... | 18054.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:29:22 | NEW HANOVER | HENNING RD & HILL RD | 1 | Traffic | 8 | 11 | 4 |
| 423886 | 40.260591 | -75.503238 | YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... | 19473.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:30:00 | LOWER FREDERICK | YERGER RD & N RYANFORD RD | 1 | Traffic | 8 | 11 | 4 |
| 423887 | 40.136020 | -75.354606 | BEECH DR & SPRUCE ST; WEST NORRITON; Station ... | 19403.0 | EMS: SEIZURES | 2018-11-16 08:39:28 | WEST NORRITON | BEECH DR & SPRUCE ST | 1 | EMS | 8 | 11 | 4 |
| 423888 | 40.230934 | -75.522125 | LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... | 19468.0 | Fire: FIRE ALARM | 2018-11-16 08:39:53 | LIMERICK | LIGHTCAP RD & SANATOGA SPRINGS DR | 1 | Fire | 8 | 11 | 4 |
| 423889 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 |
| 423890 | 40.335354 | -75.511268 | HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... | 18074.0 | Fire: FIRE POLICE NEEDED | 2018-11-16 08:45:04 | NEW HANOVER | HENNING RD | 1 | Fire | 8 | 11 | 4 |
| 423891 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 |
| 423892 | 40.107400 | -75.113206 | THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... | 19046.0 | Fire: FIRE ALARM | 2018-11-16 08:49:48 | ABINGTON | THE FAIRWAY & RYDAL RD | 1 | Fire | 8 | 11 | 4 |
| 423893 | 40.256628 | -75.261270 | LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... | 19446.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:48:24 | HATFIELD TOWNSHIP | LINE ST & COWPATH RD | 1 | Fire | 8 | 11 | 4 |
| 423894 | 40.183361 | -75.542285 | MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... | 19468.0 | EMS: FALL VICTIM | 2018-11-16 08:50:58 | ROYERSFORD | MAIN ST & 2ND AVE | 1 | EMS | 8 | 11 | 4 |
| 423895 | 40.184797 | -75.286879 | TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... | 19422.0 | EMS: SYNCOPAL EPISODE | 2018-11-16 08:47:05 | WHITPAIN | TWIN SILO DR & MORRIS RD | 1 | EMS | 8 | 11 | 4 |
| 423896 | 40.254344 | -75.407617 | HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; | NaN | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | UPPER SALFORD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
| 423897 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 |
| 423898 | 40.142797 | -75.495065 | MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... | 19460.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:43:42 | UPPER PROVIDENCE | MAC DADE RD & SCARLET OAK DR | 1 | Traffic | 8 | 11 | 4 |
| 423899 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 |
| 423900 | 40.157913 | -75.203632 | HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; | 19002.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | AMBLER | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
| 423901 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: MEDICAL ALERT ALARM | 2018-11-16 08:53:03 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 8 | 11 | 4 |
| 423902 | 40.271663 | -75.238440 | RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... | 18914.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:55:36 | MONTGOMERY | RICHARDSON RD & COUNTY LINE RD | 1 | Traffic | 8 | 11 | 4 |
| 423903 | 40.235373 | -75.224751 | HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... | 19454.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:54:52 | MONTGOMERY | HORSHAM RD & STUMP RD | 1 | Traffic | 8 | 11 | 4 |
| 423904 | 40.139993 | -75.049864 | BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... | 19006.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:08 | LOWER MORELAND | BUCK RD & WOODWARD DR | 1 | Traffic | 8 | 11 | 4 |
| 423905 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:53:32 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 |
| 423906 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:19 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 |
| 423907 | 40.190946 | -75.237285 | SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:51:48 | LOWER GWYNEDD | SUMNEYTOWN PIKE & WELLINGTON DR | 1 | Traffic | 8 | 11 | 4 |
| 423908 | 40.155164 | -75.264665 | HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; | 19422.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | LOWER GWYNEDD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 |
423909 rows × 13 columns
In [41]:
df["dates"] = df["timeStamp"].apply(lambda x:x.date())
In [42]:
df
Out[42]:
| lat | lng | desc | zip | title | timeStamp | twp | addr | e | short | hour | months | day | dates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.297876 | -75.581294 | REINDEER CT & DEAD END; NEW HANOVER; Station ... | 19525.0 | EMS: BACK PAINS/INJURY | 2015-12-10 17:10:52 | NEW HANOVER | REINDEER CT & DEAD END | 1 | EMS | 17 | 12 | 3 | 2015-12-10 |
| 1 | 40.258061 | -75.264680 | BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... | 19446.0 | EMS: DIABETIC EMERGENCY | 2015-12-10 17:29:21 | HATFIELD TOWNSHIP | BRIAR PATH & WHITEMARSH LN | 1 | EMS | 17 | 12 | 3 | 2015-12-10 |
| 2 | 40.121182 | -75.351975 | HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... | 19401.0 | Fire: GAS-ODOR/LEAK | 2015-12-10 14:39:21 | NORRISTOWN | HAWS AVE | 1 | Fire | 14 | 12 | 3 | 2015-12-10 |
| 3 | 40.116153 | -75.343513 | AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... | 19401.0 | EMS: CARDIAC EMERGENCY | 2015-12-10 16:47:36 | NORRISTOWN | AIRY ST & SWEDE ST | 1 | EMS | 16 | 12 | 3 | 2015-12-10 |
| 4 | 40.251492 | -75.603350 | CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... | NaN | EMS: DIZZINESS | 2015-12-10 16:56:52 | LOWER POTTSGROVE | CHERRYWOOD CT & DEAD END | 1 | EMS | 16 | 12 | 3 | 2015-12-10 |
| 5 | 40.253473 | -75.283245 | CANNON AVE & W 9TH ST; LANSDALE; Station 345;... | 19446.0 | EMS: HEAD INJURY | 2015-12-10 15:39:04 | LANSDALE | CANNON AVE & W 9TH ST | 1 | EMS | 15 | 12 | 3 | 2015-12-10 |
| 6 | 40.182111 | -75.127795 | LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... | 19044.0 | EMS: NAUSEA/VOMITING | 2015-12-10 16:46:48 | HORSHAM | LAUREL AVE & OAKDALE AVE | 1 | EMS | 16 | 12 | 3 | 2015-12-10 |
| 7 | 40.217286 | -75.405182 | COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... | 19426.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 16:17:05 | SKIPPACK | COLLEGEVILLE RD & LYWISKI RD | 1 | EMS | 16 | 12 | 3 | 2015-12-10 |
| 8 | 40.289027 | -75.399590 | MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... | 19438.0 | EMS: SYNCOPAL EPISODE | 2015-12-10 16:51:42 | LOWER SALFORD | MAIN ST & OLD SUMNEYTOWN PIKE | 1 | EMS | 16 | 12 | 3 | 2015-12-10 |
| 9 | 40.102398 | -75.291458 | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... | 19462.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:35:41 | PLYMOUTH | BLUEROUTE & RAMP I476 NB TO CHEMICAL RD | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 10 | 40.231990 | -75.251891 | RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:33:50 | MONTGOMERY | RT202 PKWY & KNAPP RD | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 11 | 40.084161 | -75.308386 | BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... | 19428.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 16:32:10 | PLYMOUTH | BROOK RD & COLWELL LN | 1 | Traffic | 16 | 12 | 3 | 2015-12-10 |
| 12 | 40.174131 | -75.098491 | BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... | 19040.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:15:49 | UPPER MORELAND | BYBERRY AVE & S WARMINSTER RD | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 13 | 40.062974 | -75.135914 | OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... | 19027.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:12:47 | CHELTENHAM | OLD YORK RD & VALLEY RD | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 14 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:09:49 | UPPER MERION | SCHUYLKILL EXPY & CROTON RD UNDERPASS | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 15 | 40.223778 | -75.235399 | STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... | 18936.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:31:00 | MONTGOMERY | STUMP RD & WITCHWOOD DR | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 16 | 40.243258 | -75.286552 | SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... | 19446.0 | EMS: RESPIRATORY EMERGENCY | 2015-12-10 17:42:44 | LANSDALE | SUSQUEHANNA AVE & W MAIN ST | 1 | EMS | 17 | 12 | 3 | 2015-12-10 |
| 17 | 40.312181 | -75.574260 | CHARLOTTE ST & MILES RD; NEW HANOVER; Station... | 19525.0 | EMS: DIZZINESS | 2015-12-10 17:41:54 | NEW HANOVER | CHARLOTTE ST & MILES RD | 1 | EMS | 17 | 12 | 3 | 2015-12-10 |
| 18 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... | 19401.0 | EMS: VEHICLE ACCIDENT | 2015-12-10 17:43:29 | NORRISTOWN | PENN ST & ARCH ST | 1 | EMS | 17 | 12 | 3 | 2015-12-10 |
| 19 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:45:23 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 20 | 40.114239 | -75.338508 | PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... | 19401.0 | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:43:45 | NORRISTOWN | PENN ST & ARCH ST | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 21 | 40.117948 | -75.209848 | CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... | 19031.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 17:53:22 | WHITEMARSH | CHURCH RD & REDCOAT DR | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 22 | 40.199006 | -75.300058 | LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... | 19446.0 | Fire: APPLIANCE FIRE | 2015-12-10 17:59:24 | UPPER GWYNEDD | LILAC CT & PRIMROSE DR | 1 | Fire | 17 | 12 | 3 | 2015-12-10 |
| 23 | 40.143326 | -75.422819 | RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... | NaN | Traffic: DISABLED VEHICLE - | 2015-12-10 18:00:38 | LOWER PROVIDENCE | RT422 & PAWLINGS RD OVERPASS | 1 | Traffic | 18 | 12 | 3 | 2015-12-10 |
| 24 | 40.153268 | -75.189558 | SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 17:58:22 | UPPER DUBLIN | SUMMIT AVE & RT309 UNDERPASS | 1 | Traffic | 17 | 12 | 3 | 2015-12-10 |
| 25 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: GENERAL WEAKNESS | 2015-12-10 18:02:02 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 18 | 12 | 3 | 2015-12-10 |
| 26 | 40.155283 | -75.264230 | PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... | 19422.0 | EMS: HEAD INJURY | 2015-12-10 18:02:38 | WHITPAIN | PENLLYN BLUE BELL PIKE & VILLAGE CIR | 1 | EMS | 18 | 12 | 3 | 2015-12-10 |
| 27 | 40.028903 | -75.351822 | EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... | 19085.0 | Fire: CARBON MONOXIDE DETECTOR | 2015-12-10 18:05:19 | DELAWARE COUNTY | EDENTON PL & DURHAM DR | 1 | Fire | 18 | 12 | 3 | 2015-12-10 |
| 28 | 40.097222 | -75.376195 | SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... | NaN | Traffic: VEHICLE ACCIDENT - | 2015-12-10 18:05:39 | UPPER MERION | SCHUYLKILL EXPY & WEADLEY RD OVERPASS | 1 | Traffic | 18 | 12 | 3 | 2015-12-10 |
| 29 | 40.209337 | -75.135266 | COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... | 18974.0 | Traffic: DISABLED VEHICLE - | 2015-12-10 18:10:40 | HORSHAM | COUNTY LINE RD & WILLOW DR | 1 | Traffic | 18 | 12 | 3 | 2015-12-10 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 423879 | 40.284894 | -75.583070 | BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... | 19525.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:18:15 | NEW HANOVER | BUCHERT RD & ROMIG RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423880 | 40.089043 | -75.154857 | RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... | 19095.0 | Traffic: ROAD OBSTRUCTION - | 2018-11-16 08:18:08 | CHELTENHAM | RICES MILL RD & W CHURCH RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423881 | 40.188195 | -75.195506 | TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:17:59 | HORSHAM | TENNIS AVE & WELSH RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423882 | 40.188195 | -75.195506 | WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:14:32 | UPPER DUBLIN | WELSH RD & TENNIS AVE | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423883 | 40.175671 | -75.125148 | SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... | 19044.0 | EMS: SUBJECT IN PAIN | 2018-11-16 08:27:45 | HORSHAM | SUMMIT AVE & RUTH AVE | 1 | EMS | 8 | 11 | 4 | 2018-11-16 |
| 423884 | 40.277468 | -75.260462 | BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... | 19440.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:30:54 | HATFIELD TOWNSHIP | BETHLEHEM PIKE & TREWIGTOWN RD | 1 | Fire | 8 | 11 | 4 | 2018-11-16 |
| 423885 | 40.345292 | -75.509276 | HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... | 18054.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:29:22 | NEW HANOVER | HENNING RD & HILL RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423886 | 40.260591 | -75.503238 | YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... | 19473.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:30:00 | LOWER FREDERICK | YERGER RD & N RYANFORD RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423887 | 40.136020 | -75.354606 | BEECH DR & SPRUCE ST; WEST NORRITON; Station ... | 19403.0 | EMS: SEIZURES | 2018-11-16 08:39:28 | WEST NORRITON | BEECH DR & SPRUCE ST | 1 | EMS | 8 | 11 | 4 | 2018-11-16 |
| 423888 | 40.230934 | -75.522125 | LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... | 19468.0 | Fire: FIRE ALARM | 2018-11-16 08:39:53 | LIMERICK | LIGHTCAP RD & SANATOGA SPRINGS DR | 1 | Fire | 8 | 11 | 4 | 2018-11-16 |
| 423889 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423890 | 40.335354 | -75.511268 | HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... | 18074.0 | Fire: FIRE POLICE NEEDED | 2018-11-16 08:45:04 | NEW HANOVER | HENNING RD | 1 | Fire | 8 | 11 | 4 | 2018-11-16 |
| 423891 | 40.150675 | -75.132652 | MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER MORELAND | MORELAND RD & BARTRAM RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423892 | 40.107400 | -75.113206 | THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... | 19046.0 | Fire: FIRE ALARM | 2018-11-16 08:49:48 | ABINGTON | THE FAIRWAY & RYDAL RD | 1 | Fire | 8 | 11 | 4 | 2018-11-16 |
| 423893 | 40.256628 | -75.261270 | LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... | 19446.0 | Fire: FIRE INVESTIGATION | 2018-11-16 08:48:24 | HATFIELD TOWNSHIP | LINE ST & COWPATH RD | 1 | Fire | 8 | 11 | 4 | 2018-11-16 |
| 423894 | 40.183361 | -75.542285 | MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... | 19468.0 | EMS: FALL VICTIM | 2018-11-16 08:50:58 | ROYERSFORD | MAIN ST & 2ND AVE | 1 | EMS | 8 | 11 | 4 | 2018-11-16 |
| 423895 | 40.184797 | -75.286879 | TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... | 19422.0 | EMS: SYNCOPAL EPISODE | 2018-11-16 08:47:05 | WHITPAIN | TWIN SILO DR & MORRIS RD | 1 | EMS | 8 | 11 | 4 | 2018-11-16 |
| 423896 | 40.254344 | -75.407617 | HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; | NaN | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | UPPER SALFORD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423897 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:46:39 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423898 | 40.142797 | -75.495065 | MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... | 19460.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:43:42 | UPPER PROVIDENCE | MAC DADE RD & SCARLET OAK DR | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423899 | 40.149952 | -75.134537 | W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... | 19090.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:38:23 | UPPER DUBLIN | W MORELAND RD & KIMBALL AVE | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423900 | 40.157913 | -75.203632 | HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; | 19002.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | AMBLER | HOFFMAN | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423901 | 40.133037 | -75.408463 | SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... | 19403.0 | EMS: MEDICAL ALERT ALARM | 2018-11-16 08:53:03 | LOWER PROVIDENCE | SHANNONDELL DR & SHANNONDELL BLVD | 1 | EMS | 8 | 11 | 4 | 2018-11-16 |
| 423902 | 40.271663 | -75.238440 | RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... | 18914.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:55:36 | MONTGOMERY | RICHARDSON RD & COUNTY LINE RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423903 | 40.235373 | -75.224751 | HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... | 19454.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:54:52 | MONTGOMERY | HORSHAM RD & STUMP RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423904 | 40.139993 | -75.049864 | BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... | 19006.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:08 | LOWER MORELAND | BUCK RD & WOODWARD DR | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423905 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:53:32 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423906 | 40.270121 | -75.382825 | OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... | 19438.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:54:19 | LOWER SALFORD | OAK DR & MOYER RD | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423907 | 40.190946 | -75.237285 | SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... | 19002.0 | Traffic: VEHICLE ACCIDENT - | 2018-11-16 08:51:48 | LOWER GWYNEDD | SUMNEYTOWN PIKE & WELLINGTON DR | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
| 423908 | 40.155164 | -75.264665 | HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; | 19422.0 | Traffic: DISABLED VEHICLE - | 2018-11-16 08:46:25 | LOWER GWYNEDD | HOFFMAN | 1 | Traffic | 8 | 11 | 4 | 2018-11-16 |
423909 rows × 14 columns
In [102]:
df.groupby("dates").count()["lat"].plot()
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [101]:
df[df["short"]=="EMS"].groupby("dates").count()["lat"].plot()
plt.title("EMS")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [99]:
df[df["short"]=="Traffic"].groupby("dates").count()["lat"].plot()
plt.title("Traffic")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [100]:
df[df["short"]=="Fire"].groupby("dates").count()["lat"].plot()
plt.title("Fire")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [86]:
df["short"].iplot(kind="hist",bins=50, colorscale="rdylbu")
plt.tight_layout(rect=[0, 0.02, 3, 1])
<matplotlib.figure.Figure at 0x294ccda34a8>